﻿use employees
go
------------------5----------------------------------------------------------------
SELECT 
[Dept].[ID],
[Dept].[City], 
Count([Empl].[ID]) AS [AMOUNT]
FROM [dbo].[Dept] INNER JOIN [dbo].[Empl] ON [Dept].[ID] = [Empl].[DeptID] 
GROUP BY [Dept].[ID], [Dept].[City]
ORDER BY [Dept].[City]

SELECT 
[Dept].[ID],
[Dept].[City], 
Count([Empl].[ID]) AS [AMOUNT]
FROM [dbo].[Dept], [dbo].[Empl] 
WHERE [Dept].[ID] = [Empl].[DeptID] 
GROUP BY [Dept].[ID],[Dept].[City]
ORDER BY [Dept].[City]
